
Data Analysis with Tables and PivotTables in Microsoft Excel 2013
Back To Data Analysis with Tables and PivotTables in Microsoft Excel 2013
Confident you have the skills to certify without completing the course content?
Data Analysis with Tables and PivotTables in Microsoft Excel 2013
Learn all about tables and PivotTables and how to perform data analytical techniques with this free online Excel course.
Confident you have the skills to certify without completing the course content?
- Enrolled
Positive Ratings
- Avg. Duration3-4 Hours (Contains Video)
- Available Languages (1)
English
This course is
CPD-Accredited
Learning Outcomes
In this course you will learn:
- Identify how to create a table, name a table and remove duplicate rows
- Recognize how to insert rows and columns into tables
- Discuss the use of table styles, reference and selection
- Identify the basic principles of a PivotTable
- Recognize how to create a PivotTable
- Recognize how to filter in PivotTables
- Identify how to perform data analysis using a PivotTable
- Discuss how to use the Scenario Manager
- Outline how to use Goal Seek
- Discuss how to use the Solver tool in Excel
Course Overview
About This Course
Course Description
Showcase Skills With A Certificate!
Earn credentials that matter: Anyone can say they’re learning. A CPD-accredited Alison Certificate proves you followed through.
Get an edge over others: Add your Certificate to your CV, LinkedIn, and Alison Profile to strengthen job applications and promotion opportunities.
Show you’re serious about growth: A Certificate signals initiative, commitment, and a willingness to keep learning; qualities employers actively look for.




